package com.ecoolex.chinadutyfree.retailer.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DirectMailGoodsOrderTotalDataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DirectMailGoodsOrderTotalDataExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DirectMailGoodsOrderTotalDataExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DirectMailGoodsOrderTotalDataExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DirectMailGoodsOrderTotalDataExample example = new DirectMailGoodsOrderTotalDataExample();
        return example.createCriteria();
    }

    public DirectMailGoodsOrderTotalDataExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DirectMailGoodsOrderTotalDataExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DirectMailGoodsOrderTotalDataExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderTotalDataExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderTotalDataExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("directmailgoodsordertotaldata.Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Id = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Id <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Id > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Id >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Id < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Id <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andTotalNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.TotalNumber is null");
            return (Criteria) this;
        }

        public Criteria andTotalNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.TotalNumber is not null");
            return (Criteria) this;
        }

        public Criteria andTotalNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber =", value, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber <>", value, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber >", value, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber >=", value, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber <", value, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber <=", value, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber in", values, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber not in", values, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber between", value1, value2, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andTotalNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.TotalNumber not between", value1, value2, "totalNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber is null");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber is not null");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber =", value, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber <>", value, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber >", value, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber >=", value, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber <", value, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber <=", value, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber in", values, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber not in", values, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber between", value1, value2, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andUnpaidNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.UnpaidNumber not between", value1, value2, "unpaidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.PaidNumber is null");
            return (Criteria) this;
        }

        public Criteria andPaidNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.PaidNumber is not null");
            return (Criteria) this;
        }

        public Criteria andPaidNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber =", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber <>", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber >", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber >=", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber <", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber <=", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber in", values, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber not in", values, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber between", value1, value2, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.PaidNumber not between", value1, value2, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber is null");
            return (Criteria) this;
        }

        public Criteria andShippedNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber is not null");
            return (Criteria) this;
        }

        public Criteria andShippedNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber =", value, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber <>", value, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber >", value, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber >=", value, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber <", value, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber <=", value, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber in", values, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber not in", values, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber between", value1, value2, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andShippedNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.ShippedNumber not between", value1, value2, "shippedNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber is null");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber =", value, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber <>", value, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber >", value, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber >=", value, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber <", value, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber <=", value, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber in", values, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber not in", values, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber between", value1, value2, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andConfirmNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.ConfirmNumber not between", value1, value2, "confirmNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.CancelNumber is null");
            return (Criteria) this;
        }

        public Criteria andCancelNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.CancelNumber is not null");
            return (Criteria) this;
        }

        public Criteria andCancelNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber =", value, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber <>", value, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber >", value, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber >=", value, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber <", value, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber <=", value, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber in", values, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber not in", values, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber between", value1, value2, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andCancelNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.CancelNumber not between", value1, value2, "cancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber is null");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber is not null");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber =", value, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber <>", value, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber >", value, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber >=", value, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber <", value, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber <=", value, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber in", values, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber not in", values, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber between", value1, value2, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andAutoCancelNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelNumber not between", value1, value2, "autoCancelNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber is null");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber is not null");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber =", value, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber <>", value, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber >", value, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber >=", value, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber <", value, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber <=", value, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber in", values, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber not in", values, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber between", value1, value2, "successNumber");
            return (Criteria) this;
        }

        public Criteria andSuccessNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.SuccessNumber not between", value1, value2, "successNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber is null");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber is not null");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber =", value, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber <>", value, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber >", value, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber >=", value, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber <", value, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber <=", value, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber in", values, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber not in", values, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber between", value1, value2, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andAfterSalesNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesNumber not between", value1, value2, "afterSalesNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.CloseNumber is null");
            return (Criteria) this;
        }

        public Criteria andCloseNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.CloseNumber is not null");
            return (Criteria) this;
        }

        public Criteria andCloseNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber =", value, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CloseNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCloseNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber <>", value, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CloseNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCloseNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber >", value, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CloseNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCloseNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber >=", value, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CloseNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCloseNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber <", value, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CloseNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCloseNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber <=", value, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CloseNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCloseNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber in", values, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber not in", values, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber between", value1, value2, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andCloseNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.CloseNumber not between", value1, value2, "closeNumber");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.TotalPrice is null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.TotalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice =", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice <>", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice >", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice >=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice <", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice <=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.TotalPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice not in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.TotalPrice not between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice is null");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice is not null");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice =", value, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice <>", value, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice >", value, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice >=", value, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice <", value, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice <=", value, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UnpaidPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice in", values, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice not in", values, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice between", value1, value2, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andUnpaidPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.UnpaidPrice not between", value1, value2, "unpaidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.PaidPrice is null");
            return (Criteria) this;
        }

        public Criteria andPaidPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.PaidPrice is not null");
            return (Criteria) this;
        }

        public Criteria andPaidPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice =", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice <>", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice >", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice >=", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice <", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice <=", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice in", values, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice not in", values, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice between", value1, value2, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.PaidPrice not between", value1, value2, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice is null");
            return (Criteria) this;
        }

        public Criteria andShippedPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice is not null");
            return (Criteria) this;
        }

        public Criteria andShippedPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice =", value, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice <>", value, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice >", value, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice >=", value, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice <", value, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice <=", value, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ShippedPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice in", values, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice not in", values, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice between", value1, value2, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andShippedPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.ShippedPrice not between", value1, value2, "shippedPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice is null");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice =", value, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmReceiptPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice <>", value, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmReceiptPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice >", value, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmReceiptPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice >=", value, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmReceiptPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice <", value, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmReceiptPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice <=", value, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ConfirmReceiptPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice in", values, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice not in", values, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice between", value1, value2, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.ConfirmReceiptPrice not between", value1, value2, "confirmReceiptPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.CancelPrice is null");
            return (Criteria) this;
        }

        public Criteria andCancelPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.CancelPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCancelPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice =", value, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice <>", value, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice >", value, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice >=", value, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice <", value, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice <=", value, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CancelPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice in", values, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice not in", values, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice between", value1, value2, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andCancelPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.CancelPrice not between", value1, value2, "cancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice is null");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice is not null");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice =", value, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice <>", value, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice >", value, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice >=", value, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice <", value, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice <=", value, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AutoCancelPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice in", values, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice not in", values, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice between", value1, value2, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andAutoCancelPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.AutoCancelPrice not between", value1, value2, "autoCancelPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice is null");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice is not null");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice =", value, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice <>", value, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice >", value, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice >=", value, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice <", value, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice <=", value, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.SuccessPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSuccessPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice in", values, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice not in", values, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice between", value1, value2, "successPrice");
            return (Criteria) this;
        }

        public Criteria andSuccessPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.SuccessPrice not between", value1, value2, "successPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice is null");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice is not null");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice =", value, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice <>", value, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice >", value, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice >=", value, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice <", value, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice <=", value, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AfterSalesPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice in", values, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice not in", values, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice between", value1, value2, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andAfterSalesPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.AfterSalesPrice not between", value1, value2, "afterSalesPrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.ClosePrice is null");
            return (Criteria) this;
        }

        public Criteria andClosePriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.ClosePrice is not null");
            return (Criteria) this;
        }

        public Criteria andClosePriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice =", value, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ClosePrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClosePriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice <>", value, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ClosePrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClosePriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice >", value, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ClosePrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClosePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice >=", value, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ClosePrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClosePriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice <", value, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ClosePrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClosePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice <=", value, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.ClosePrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClosePriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice in", values, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice not in", values, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice between", value1, value2, "closePrice");
            return (Criteria) this;
        }

        public Criteria andClosePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.ClosePrice not between", value1, value2, "closePrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice is null");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice is not null");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice =", value, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgPaidPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice <>", value, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgPaidPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice >", value, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgPaidPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice >=", value, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgPaidPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice <", value, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgPaidPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice <=", value, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgPaidPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice in", values, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice not in", values, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice between", value1, value2, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgPaidPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.AvgPaidPrice not between", value1, value2, "avgPaidPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceIsNull() {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice is null");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice is not null");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice =", value, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgCustomerPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice <>", value, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgCustomerPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice >", value, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgCustomerPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice >=", value, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgCustomerPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice <", value, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgCustomerPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice <=", value, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.AvgCustomerPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice in", values, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice not in", values, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice between", value1, value2, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andAvgCustomerPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsordertotaldata.AvgCustomerPrice not between", value1, value2, "avgCustomerPrice");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberIsNull() {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber is null");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber is not null");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber =", value, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidUserNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber <>", value, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidUserNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber >", value, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidUserNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber >=", value, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidUserNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberLessThan(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber <", value, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidUserNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber <=", value, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.PaidUserNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber in", values, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber not in", values, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber between", value1, value2, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andPaidUserNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsordertotaldata.PaidUserNumber not between", value1, value2, "paidUserNumber");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("directmailgoodsordertotaldata.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("directmailgoodsordertotaldata.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("directmailgoodsordertotaldata.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("directmailgoodsordertotaldata.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsordertotaldata.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("directmailgoodsordertotaldata.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsordertotaldata.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("directmailgoodsordertotaldata.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("directmailgoodsordertotaldata.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsordertotaldata.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsordertotaldata.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsordertotaldata.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("directmailgoodsordertotaldata.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsordertotaldata.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsordertotaldata.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsordertotaldata.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsordertotaldata.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("directmailgoodsordertotaldata.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsordertotaldata.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsordertotaldata.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsordertotaldata.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsordertotaldata.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsordertotaldata.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("directmailgoodsordertotaldata.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsordertotaldata.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("directmailgoodsordertotaldata.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("directmailgoodsordertotaldata.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DirectMailGoodsOrderTotalData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsordertotaldata.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsordertotaldata.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DirectMailGoodsOrderTotalDataExample example;

        protected Criteria(DirectMailGoodsOrderTotalDataExample example) {
            super();
            this.example = example;
        }

        public DirectMailGoodsOrderTotalDataExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DirectMailGoodsOrderTotalData.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DirectMailGoodsOrderTotalData.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.chinadutyfree.retailer.entity.DirectMailGoodsOrderTotalDataExample example);
    }
}